/*
MySQL Backup
Database: tube
Backup Time: 2024-10-01 18:08:36
*/

SET FOREIGN_KEY_CHECKS=0;
DROP TABLE IF EXISTS `tube`.`point`;
CREATE TABLE `point` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL,
  `lat` varchar(255) DEFAULT NULL,
  `lng` varchar(255) DEFAULT NULL,
  `state` int(255) DEFAULT NULL,
  `priority` int(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=49 DEFAULT CHARSET=utf8mb4;
BEGIN;
LOCK TABLES `tube`.`point` WRITE;
DELETE FROM `tube`.`point`;
INSERT INTO `tube`.`point` (`id`,`name`,`lat`,`lng`,`state`,`priority`) VALUES (1, '图书馆', '39.916381', '119.539103', 1, 14),(2, '四组团', '39.911338', '119.527623', 1, 2),(3, '里仁学院', '39.912299', '119.533363', 1, 0),(4, '西三', '39.916450', '119.530058', 1, 4),(5, '燕园食堂', '39.917114', '119.525009', 1, 5),(6, '信息管', '39.923547', '119.527488', 1, 6),(7, '大食堂', '39.913749', '119.527219', 1, 7),(8, '广缘超市', '39.914181', '119.524456', 1, 8),(9, '东四教', '39.915032', '119.545958', 1, 9),(10, '东一教', '39.910840', '119.545616', 1, 5),(11, '东二教', '39.909933', '119.544314', 1, 11),(12, '东大活', '39.907671', '119.543936', 1, 12),(13, '世纪楼', '39.911161', '119.543896', 1, 13),(14, '大转盘', '39.913396', '119.530704', 1, 999),(15, '西大活', '39.910971', '119.53207', 1, 999),(18, '艺术学院', '39.920932', '119.527825', 1, 999),(19, '七号门', '39.910487', '119.530507', 1, 999),(20, '里仁实验楼', '39.911687', '119.535838', 1, 999),(22, '四体体育场', '39.91966', '119.522054', 1, 999),(23, '西二', '39.916969', '119.529563', 1, 999),(24, '西一', '39.917467', '119.528962', 1, 999),(25, '六号门', '39.924259', '119.524641', 1, 999),(26, '五号门', '39.917294', '119.542346', 1, 999),(27, '一号门', '39.908674', '119.546964', 1, 999),(28, '二号门', '39.910625', '119.549093', 1, 999),(30, '燕园派出所', '39.917785', '119.549838', 1, 999),(31, '东区体育馆', '39.917335', '119.546281', 1, 999),(32, '二体', '39.91782', '119.547745', 1, 999),(33, '东区七舍', '39.910888', '119.541241', 1, 999),(34, '艺术学院', '39.919971', '119.526303', 1, 999),(35, '燕宏桥', '39.914485', '119.54329', 1, 999),(36, '雁鸣湖食堂', '39.910009', '119.542221', 1, 999),(37, '中快', '39.909013', '119.54231', 1, 999),(38, '服务楼', '39.908308', '119.543038', 1, 999),(39, '四号门', '39.915834', '119.544332', 1, 999),(40, '电气学院', '39.916287', '119.527969', 1, 999),(41, '理学院', '39.923595', '119.529024', 1, 999),(42, '材料学院', '39.912597', '119.531782', 1, 999),(43, '一体', '39.908705', '119.545248', 1, 999),(44, '三体', '39.911929', '119.537554', 1, 999),(45, '环化管', '39.910359', '119.54629', 1, 999),(46, '建工管', '39.911199', '119.547309', 1, 999),(47, '机械管', '39.911397', '119.544987', 1, 999),(48, '二教', '39.912223', '119.546124', 1, 999);
UNLOCK TABLES;
COMMIT;
